/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.2.45
 Source Server Type    : MySQL
 Source Server Version : 50651 (5.6.51-log)
 Source Host           : 192.168.2.45:3306
 Source Schema         : star

 Target Server Type    : MySQL
 Target Server Version : 50651 (5.6.51-log)
 File Encoding         : 65001

 Date: 08/11/2023 16:26:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for data_sources
-- ----------------------------
DROP TABLE IF EXISTS `data_sources`;
CREATE TABLE `data_sources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source_name` varchar(100) NOT NULL,
  `source_address` varchar(500) DEFAULT NULL,
  `user_name` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `source_type` varchar(100) DEFAULT NULL,
  `host` varchar(100) DEFAULT NULL,
  `port` varchar(100) DEFAULT NULL,
  `database_name` varchar(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0' COMMENT '0 启动  1 停止',
  PRIMARY KEY (`id`,`source_name`) USING BTREE,
  UNIQUE KEY `data_sources_source_name_IDX` (`source_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2107 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of data_sources
-- ----------------------------
BEGIN;
INSERT INTO `data_sources` (`id`, `source_name`, `source_address`, `user_name`, `password`, `source_type`, `host`, `port`, `database_name`, `status`) VALUES (1, 'mysql', 'jdbc:mysql://192.168.2.43:13306/star', 'root', 'zd123456', 'mysql', '192.168.2.43', '13306', 'star', 0);
INSERT INTO `data_sources` (`id`, `source_name`, `source_address`, `user_name`, `password`, `source_type`, `host`, `port`, `database_name`, `status`) VALUES (2, 'kafka_input', 'cdh001:9092,cdh002:9092,cdh003:9092', NULL, NULL, NULL, NULL, '9092', NULL, 0);
INSERT INTO `data_sources` (`id`, `source_name`, `source_address`, `user_name`, `password`, `source_type`, `host`, `port`, `database_name`, `status`) VALUES (3, 'starrocks_server', 'jdbc-url=jdbc:mysql://192.168.1.94:9030|load-url=192.168.1.94:8030', 'roohom', '123456', 'starrocks', NULL, NULL, 'star', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
